USE [CMS]
GO

/****** Object:  View [dbo].[VW_Users]    Script Date: 12/27/2012 11:14:19 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[VW_Users]
AS
SELECT     dbo.Users.ADM_ID, dbo.Users.USR_ID, dbo.Users.USR_NAME, dbo.Users.USR_PASSWORD, dbo.Users.USR_EMAIL, dbo.Users.USR_DATE, dbo.Users.MUT_DELETED, 
                      dbo.Administration.ADM_CODE, dbo.Administration.ADM_NAME, dbo.Users.USR_ACTIVE, dbo.Users.USR_LASTLOGIN, dbo.Users.USR_MASTERUSER
FROM         dbo.Users LEFT OUTER JOIN
                      dbo.Administration ON dbo.Users.ADM_ID = dbo.Administration.ADM_ID
WHERE     (dbo.Users.MUT_DELETED IS NULL)

GO
